{
  "properties" : { },
  "id" : "copy1725349897056d76769",
  "script" : null,
  "groupId" : "0ae13df90a5c41a7930f46ab7d7936cb",
  "name" : "查询未关联属性",
  "createTime" : 1727070888696,
  "updateTime" : 1725350514342,
  "lock" : "1",
  "createBy" : "ndmp",
  "updateBy" : "ndmp",
  "path" : "queryUnbindAttribute",
  "method" : "GET",
  "parameters" : [ {
    "name" : "modelId",
    "value" : "1735550202917445634",
    "description" : null,
    "required" : true,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  } ],
  "options" : [ ],
  "requestBody" : "",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"status\": 200,\n    \"message\": \"success\",\n    \"data\": {\n        \"total\": 66,\n        \"current\": 1,\n        \"size\": 30,\n        \"records\": [\n            {\n                \"id\": \"1656562842510352386\",\n                \"name\": \"内存使用率\",\n                \"fromField\": \"\",\n                \"fromTable\": \"memUsage\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"16\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"1\"\n            },\n            {\n                \"id\": \"1656563166843297793\",\n                \"name\": \"内存大小\",\n                \"fromField\": \"mem_size\",\n                \"fromTable\": \"ndmp_running_net_device_data\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"17\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"2\"\n            },\n            {\n                \"id\": \"1656563658147291138\",\n                \"name\": \"使用内存\",\n                \"fromField\": \"use_mem_size\",\n                \"fromTable\": \"ndmp_running_net_device_data\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"18\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"3\"\n            },\n            {\n                \"id\": \"1656564022187712514\",\n                \"name\": \"空闲内存\",\n                \"fromField\": \"free_mem_size\",\n                \"fromTable\": \"ndmp_running_net_device_data\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"19\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"4\"\n            },\n            {\n                \"id\": \"1656564367567675393\",\n                \"name\": \"数据时间\",\n                \"fromField\": \"data_time\",\n                \"fromTable\": \"ndmp_running_net_device_data\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"20\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"5\"\n            },\n            {\n                \"id\": \"1656564664847360002\",\n                \"name\": \"丢包率\",\n                \"fromField\": \"packet-loss\",\n                \"fromTable\": \"ndmp_running_net_device_data\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"21\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"6\"\n            },\n            {\n                \"id\": \"1656564923199709186\",\n                \"name\": \"平均时延\",\n                \"fromField\": \"average_delay\",\n                \"fromTable\": \"ndmp_running_net_device_data\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"22\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"7\"\n            },\n            {\n                \"id\": \"1656569450208485377\",\n                \"name\": \"接口别名\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ifAlias\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"23\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"8\"\n            },\n            {\n                \"id\": \"1656569935913082882\",\n                \"name\": \"接口MAC地址\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ifPhysAddress\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"24\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"9\"\n            },\n            {\n                \"id\": \"1656570438315204609\",\n                \"name\": \"接口描述\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ifDescr\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"25\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"10\"\n            },\n            {\n                \"id\": \"1656570930067988482\",\n                \"name\": \"实际带宽\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ifHighSpeed\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"26\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"11\"\n            },\n            {\n                \"id\": \"1656571746778669058\",\n                \"name\": \"接口类型\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ifType\",\n                \"fromDb\": \"5\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"27\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"ifType\",\n                \"rowId\": \"12\"\n            },\n            {\n                \"id\": \"1656571963561271297\",\n                \"name\": \"接口ip\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ifIp\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"28\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"13\"\n            },\n            {\n                \"id\": \"1656572362695434241\",\n                \"name\": \"接口速率\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ifFlowSpeed\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"29\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"14\"\n            },\n            {\n                \"id\": \"1656572633685221378\",\n                \"name\": \"接口数据时间\",\n                \"fromField\": \"data_time\",\n                \"fromTable\": \"ndmp_net_if_info\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"30\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"15\"\n            },\n            {\n                \"id\": \"1656583650230181890\",\n                \"name\": \"端口索引编号\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ipNetToMediaIfIndex\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"32\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"16\"\n            },\n            {\n                \"id\": \"1656584015755386881\",\n                \"name\": \"接口mac地址\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ipNetToMediaPhysAddress\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"-1\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"17\"\n            },\n            {\n                \"id\": \"1656584571005739010\",\n                \"name\": \"接口ip地址\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ipNetToMediaNetAddress\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"34\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"18\"\n            },\n            {\n                \"id\": \"1656584945276067841\",\n                \"name\": \"映射类型\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ipNetToMediaType\",\n                \"fromDb\": \"5\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"35\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"ipNetToMediaType\",\n                \"rowId\": \"19\"\n            },\n            {\n                \"id\": \"1656607917302939650\",\n                \"name\": \"读写端口\",\n                \"fromField\": \"port_rw\",\n                \"fromTable\": \"ndmp_net_snmp_protocol\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"37\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"20\"\n            },\n            {\n                \"id\": \"1656608375031529473\",\n                \"name\": \"只读团体字\",\n                \"fromField\": \"rocommunity\",\n                \"fromTable\": \"ndmp_net_snmp_protocol\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"38\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"21\"\n            },\n            {\n                \"id\": \"1656608639331401729\",\n                \"name\": \"读写团体字\",\n                \"fromField\": \"rwcommunity\",\n                \"fromTable\": \"ndmp_net_snmp_protocol\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"39\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"22\"\n            },\n            {\n                \"id\": \"1656610529184120834\",\n                \"name\": \"协议类型\",\n                \"fromField\": \"pro_type\",\n                \"fromTable\": \"ndmp_net_device_protocol\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"40\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"23\"\n            },\n            {\n                \"id\": \"1656610824265990146\",\n                \"name\": \"ssh用户名\",\n                \"fromField\": \"device_username\",\n                \"fromTable\": \"ndmp_net_device_protocol\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"41\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"24\"\n            },\n            {\n                \"id\": \"1656611168375078913\",\n                \"name\": \"ssh协议端口\",\n                \"fromField\": \"device_port\",\n                \"fromTable\": \"ndmp_net_device_protocol\",\n                \"fromDb\": \"3\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"10\",\n                \"sort\": \"42\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"25\"\n            },\n            {\n                \"id\": \"1657930281995276290\",\n                \"name\": \"目的网段\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ipRouteDest\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"\",\n                \"sort\": \"49\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"26\"\n            },\n            {\n                \"id\": \"1657940703070720002\",\n                \"name\": \"掩码\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ipRouteMask\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"10\",\n                \"sort\": \"50\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"27\"\n            },\n            {\n                \"id\": \"1657940849368043521\",\n                \"name\": \"下一跳\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ipRouteNextHop\",\n                \"fromDb\": \"2\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"10\",\n                \"sort\": \"51\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"\",\n                \"rowId\": \"28\"\n            },\n            {\n                \"id\": \"1657941012727795714\",\n                \"name\": \"路由类别\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ipRouteType\",\n                \"fromDb\": \"5\",\n                \"count\": \"-1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"10\",\n                \"sort\": \"-1\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"ipRouteType\",\n                \"rowId\": \"29\"\n            },\n            {\n                \"id\": \"1658766308204912642\",\n                \"name\": \"路由协议\",\n                \"fromField\": \"\",\n                \"fromTable\": \"ipRouteProto\",\n                \"fromDb\": \"5\",\n                \"count\": \"1\",\n                \"dateFormatter\": \"\",\n                \"width\": \"33%\",\n                \"minWidth\": \"10\",\n                \"sort\": \"4\",\n                \"englishName\": \"\",\n                \"sqlStatement\": \"ipRouteProto\",\n                \"rowId\": \"30\"\n            }\n        ]\n    }\n}",
  "description" : "",
  "requestBodyDefinition" : {
    "name" : "",
    "value" : { },
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  },
  "responseBodyDefinition" : {
    "name" : "",
    "value" : { },
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  }
}
================================
sql="""
        SELECT * from ndmp_dynamic_model_attribute where id not in (
        SELECT a.id FROM ndmp_dynamic_model_attribute a,ndmp_dynamic_model_relation r
        where a.id = r.column_id and r.model_id = #{modelId})
"""
return db.page(sql)